﻿using System;
using System.Collections.Generic;
using System.Dynamic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace clf.code.first
{
    internal class Constract
    {
        public static readonly string defaultStr = " DEFAULT ";
        public static readonly string CommentStr = " COMMENT ";

        public static readonly string AlertTablr = "ALTER TABLE ";
        public static readonly string Drop = " DROP ";
        public static readonly string Add = " ADD ";


        //-- ALTER TABLE car_info ADD COLUMN `nmae` VARCHAR(10) NOT NULL DEFAULT 'test' COMMENT '';
        //-- ALTER TABLE car_info CHANGE  COLUMN `nmae`  `name` VARCHAR(300) NOT NULL DEFAULT 'var' COMMENT 'test';
        //-- ALTER TABLE car_info DROP COLUMN `name`;

        //DESC car_info;
        //除了列的重命名之外，他干的活和CHANGE COLUMN是一样的。
        //alter table user modify COLUMN `id`   BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键ID';

        //https://blog.csdn.net/riant110/article/details/118400042
    }
}
